create external table jms_dm.dm_centersend_warning_sum_hi (
   center_code string comment '规划转运中心code',
   center_name string comment '规划转运中心',
   entrpot_code string comment '下一站集散点1code',
   entrpot_name string comment '下一站集散点1',
   next_entrpot_code string comment '集散点2code',
   next_entrpot_name string comment '集散点2',
   network_code string comment '网点code',
   network_name string comment '网点',
   agent_code string comment '代理区code',
   agent_name string comment '代理区',                             
   shift_classes string comment '散货班次',
   planned_sned_time string comment '规划发车时间',
   planned_arrival_time string comment '规划到车时间',
   center_send_num string comment '干线在途',
   site_send_num string comment '支线在途',
   center_stop_num string comment '中心滞留',
   first_siet_send_num string comment '网点已揽未发',
   dest_center_send_num string comment '中心发件数据',
   etl_time string comment '数据更新时间',
   query_date string comment 'query_date',
   date_time string comment 'date_time'
) COMMENT '临时表'
PARTITIONED BY (dt STRING COMMENT '')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_centersend_warning_sum_hi'
TBLPROPERTIES (
'discover.partitions'='false',
'parquet.column.index.access'='true'

);   